Professional Cloud Database Engineer v1.0

Page:    1 / 9   
Exam contains 137 questions
Expand All

You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?

  • A. Check the cloudsql.googleapis.com/postgres.log instance log.
  • B. Perform the gcloud sql operations list command.
  • C. Use Cloud Audit Logs to verify the status.
  • D. Use the Google Cloud Console.


Answer : C

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

  • A. Increase the number of processing units.
  • B. Modify the database schema, and add additional indexes.
  • C. Shard data required by the application into multiple instances.
  • D. Decrease the number of processing units.


Answer : A

Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

  • A. Recommend solid-state drives (SSD).
  • B. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
  • C. Recommend hard disk drives (HDD).
  • D. Recommend mixed storage types.


Answer : B

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

  • A. 1. Provision a Cloud SQL for MySQL instance in us-central1-a.
    2. Create a multiple-zone instance in us-west1-b.
    3. Create a read replica in us-east1-c.
  • B. 1. Provision a Cloud SQL for MySQL instance in us-central1-a.
    2. Create a multiple-zone instance in us-central1-b.
    3. Create a read replica in us-east1-b.
  • C. 1. Provision a Cloud SQL for MySQL instance in us-central1-a.
    2. Create a multiple-zone instance in us-east-b.
    3. Create a read replica in us-east1-c.
  • D. 1. Provision a Cloud SQL for MySQL instance in us-central1-a.
    2. Create a multiple-zone instance in us-east1-b.
    3. Create a read replica in us-central1-b.


Answer : B

You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?

  • A. Use Firestore.
  • B. Use Cloud SQL with an external (public) IP address.
  • C. Use an in-app embedded database.
  • D. Use Cloud Spanner.


Answer : B

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

  • A. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
  • B. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
  • C. If the corruption is significant, use import and export.
  • D. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
  • E. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.


Answer : BE

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?

  • A. Close idle connections or restart the instance before beginning the import operation.
  • B. Increase the amount of memory allocated to your instance.
  • C. Ensure that the service account has the Storage Admin role.
  • D. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.


Answer : C

You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

  • A. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
  • B. Set up Serverless VPC Access.
  • C. Set up Private Service Connect.
  • D. Set up Traffic Director.


Answer : A

You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?

  • A. Use Cloud Functions to run the export in Avro format.
  • B. Use Cloud Functions to run the export in text format.
  • C. Use Dataflow to run the export in Avro format.
  • D. Use Dataflow to run the export in text format.


Answer : C

You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

  • A. Configure Firestore, and modify your application to offload queries.
  • B. Configure Bigtable, and modify your application to offload queries.
  • C. Configure Cloud SQL for PostgreSQL read replicas to offload queries.
  • D. Configure Memorystore, and modify your application to offload queries.


Answer : D

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

  • A. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
  • B. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
  • C. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
  • D. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.


Answer : B

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

  • A. Take no backups, and turn off transaction log retention.
  • B. Take one manual backup per day, and turn off transaction log retention.
  • C. Turn on automated backup, and turn off transaction log retention.
  • D. Turn on automated backup, and turn on transaction log retention.


Answer : B

You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?

  • A. Set your production instance's maintenance window to non-business hours.
  • B. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
  • C. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
  • D. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.


Answer : B

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

  • A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
  • B. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
  • C. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
  • D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.


Answer : B

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

  • A. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
  • B. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
  • C. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
  • D. Use Cloud Composer to execute a select * from table(s) query and export results.


Answer : A

Page:    1 / 9   
Exam contains 137 questions
Expand All

Talk to us!

Have any questions or issues ? Please dont hesitate to contact us

[email protected]

Certlibrary.com is owned by MBS Tech Limited: Room 1905 Nam Wo Hong Building, 148 Wing Lok Street, Sheung Wan, Hong Kong. Company registration number: 2310926
Certlibrary doesn't offer Real Microsoft Exam Questions. Certlibrary Materials do not contain actual questions and answers from Cisco's Certification Exams.
CFA Institute does not endorse, promote or warrant the accuracy or quality of Certlibrary. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Terms & Conditions | Privacy Policy